package com.pearadmin.pro.modules.experiment.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.pearadmin.pro.modules.experiment.entity.ExperimentMajor;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * 专业分类持久化层
 *
 * @author ZhouXingYun
 * @date 2022/6/15 9:58
 */
@Mapper
public interface ExperimentMajorDao extends BaseMapper<ExperimentMajor> {
    int deleteByPrimaryKey(Integer id);

    int insertSelective(ExperimentMajor record);

    ExperimentMajor selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(ExperimentMajor record);

    int updateByPrimaryKey(ExperimentMajor record);

    /**
     * 获取一级筛选列表
     * @author ZhouXingYun
     * @date 2022/6/15 10:14
     * @return java.util.List<com.pearadmin.pro.modules.experiment.entity.ExperimentMajor>
     */
    List<ExperimentMajor> filtrate();

    List<ExperimentMajor> getClssify(Integer id);

    String selectName(Integer major);

    List<ExperimentMajor> tree();

}
